{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "908d636d",
   "metadata": {},
   "source": [
    "# 1.位置信息"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "2782e2dd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'113.678280,23.628439'"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import requests\n",
    "geo_url = \"https://restapi.amap.com/v3/geocode/geo?parameters\"\n",
    "payload = {\n",
    "    \"key\":\"f7b3c94b56fe002e2b98f6bb8d8a5f46\",\n",
    "    \"address\":\"广东省广州市从化区广州南方学院\"\n",
    "}\n",
    "r = requests.get(url=geo_url, params=payload)\n",
    "广州南方学院_location = r.json()['geocodes'][0]['location']\n",
    "广州南方学院_location"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4027b2a5",
   "metadata": {},
   "source": [
    "# 搜索POI\n",
    "* 搜索方式\n",
    "> 1. keywords(关键词)\n",
    "> 2. types(分类-例如高德的分类)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "11514737",
   "metadata": {},
   "outputs": [],
   "source": [
    "around_url = 'https://restapi.amap.com/v3/place/around?parameters'\n",
    "\n",
    "payload = {\n",
    "    \"key\":\"f7b3c94b56fe002e2b98f6bb8d8a5f46\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"keywords\":\"篮球场\"\n",
    "}\n",
    "r = requests.get(around_url,params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "075e4f95",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "cfdf3d17",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'suggestion': {'keywords': [], 'cities': []},\n",
       " 'count': '96',\n",
       " 'infocode': '10000',\n",
       " 'pois': [{'parent': [],\n",
       "   'address': '博学路20号',\n",
       "   'distance': '142',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': []},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;篮球场馆',\n",
       "   'photos': [],\n",
       "   'typecode': '080104',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '广州南方学院-西区篮球场',\n",
       "   'location': '113.677851,23.629654',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1XKYTYG'},\n",
       "  {'parent': [],\n",
       "   'address': '博学路2号',\n",
       "   'distance': '615',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': []},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;篮球场馆',\n",
       "   'photos': [],\n",
       "   'typecode': '080104',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '广州南方学院-西区大篮球场',\n",
       "   'location': '113.676146,23.633610',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HRVOFC24'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇云星大道流溪河畔华辉度假村',\n",
       "   'distance': '4558',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '4.0'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;篮球场馆',\n",
       "   'photos': [],\n",
       "   'typecode': '080104',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '华辉度假村-篮球馆',\n",
       "   'location': '113.634306,23.621128',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B00141SY2P'},\n",
       "  {'parent': [],\n",
       "   'address': '麻村西井新村十巷十四号',\n",
       "   'distance': '6989',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '3.7'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;体育休闲服务场所;体育休闲服务场所',\n",
       "   'photos': [],\n",
       "   'typecode': '080000',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '从化麻一村蓝球场',\n",
       "   'location': '113.613966,23.606772',\n",
       "   'tel': '13609053811',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFHDSVYX'},\n",
       "  {'parent': [],\n",
       "   'address': '御泉大道与马会大街交叉口西300米',\n",
       "   'distance': '7986',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '4.3'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;篮球场馆',\n",
       "   'photos': [],\n",
       "   'typecode': '080104',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '滴翠山庄-篮球场',\n",
       "   'location': '113.709579,23.694209',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFGBJL7Z'},\n",
       "  {'parent': [],\n",
       "   'address': 'G105(京珠线)',\n",
       "   'distance': '8563',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': []},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;篮球场馆',\n",
       "   'photos': [],\n",
       "   'typecode': '080104',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '虫湾自菽水碧温泉度假村-篮球场',\n",
       "   'location': '113.714658,23.697773',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HKLSPFIL'},\n",
       "  {'parent': [],\n",
       "   'address': '绿道永盛花园南侧约60米',\n",
       "   'distance': '11454',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '3.4'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;篮球场馆',\n",
       "   'photos': [],\n",
       "   'typecode': '080104',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '广州市流溪河碧道-篮球场',\n",
       "   'location': '113.603998,23.551285',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HK09FJU4'},\n",
       "  {'parent': [],\n",
       "   'address': '城郊街新星村大夫围',\n",
       "   'distance': '11624',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '3.8'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;体育休闲服务场所;体育休闲服务场所',\n",
       "   'photos': [],\n",
       "   'typecode': '080000',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '大夫围篮球场',\n",
       "   'location': '113.568239,23.601258',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0GRCUDOG2'},\n",
       "  {'parent': [],\n",
       "   'address': '城郊街河滨北路向阳村十壮大车87号',\n",
       "   'distance': '11644',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '3.7'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;篮球场馆',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/58c53b0fbccc63cfa2b85cc544757c66'}],\n",
       "   'typecode': '080104',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '东风530篮球俱乐部',\n",
       "   'location': '113.599433,23.552791',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HGYDWCTV'},\n",
       "  {'parent': [],\n",
       "   'address': '郊街新村北路',\n",
       "   'distance': '12273',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '3.4'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;运动场所',\n",
       "   'photos': [],\n",
       "   'typecode': '080100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '篮球广场',\n",
       "   'location': '113.586581,23.557058',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFL1ERXT'},\n",
       "  {'parent': [],\n",
       "   'address': '西街市场',\n",
       "   'distance': '12581',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '3.7'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;体育休闲服务场所;体育休闲服务场所',\n",
       "   'photos': [],\n",
       "   'typecode': '080000',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '田边村球场',\n",
       "   'location': '113.588417,23.551027',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFIVT1AD'},\n",
       "  {'parent': [],\n",
       "   'address': '河东南路1-7号附近',\n",
       "   'distance': '12639',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '4.5'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;篮球场馆',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/8104df48263d05da42ae14eef6881689'}],\n",
       "   'typecode': '080104',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '华蒙星少儿篮球俱乐部(街口店)',\n",
       "   'location': '113.595492,23.543939',\n",
       "   'tel': '020-87966066',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFL0DDYS'},\n",
       "  {'parent': [],\n",
       "   'address': '萃安里58号',\n",
       "   'distance': '13255',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '4.2'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;篮球场馆',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://aos-cdn-image.amap.com/sns/ugccomment/7e7d4deb-c78b-4a1e-96cf-51c24a53926e.jpg'},\n",
       "    {'title': [],\n",
       "     'url': 'http://aos-cdn-image.amap.com/sns/ugccomment/d4407b0c-4932-4bfa-b01f-74e6ea844747.jpg'},\n",
       "    {'title': [],\n",
       "     'url': 'http://aos-cdn-image.amap.com/sns/ugccomment/75bb1cfd-ea69-4529-9a59-ff1d5e711469.jpg'}],\n",
       "   'typecode': '080104',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '广州星跃篮球训练馆',\n",
       "   'location': '113.581199,23.549290',\n",
       "   'tel': '18620199644',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFKL6J9B'},\n",
       "  {'parent': [],\n",
       "   'address': '河东南路272号',\n",
       "   'distance': '13355',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '4.3'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;运动场所',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/efe1e46ca58ff1a360c9af1e0f9b5994'}],\n",
       "   'typecode': '080100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '健乐球馆',\n",
       "   'location': '113.599421,23.532675',\n",
       "   'tel': '020-87982828',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFI1TFV5'},\n",
       "  {'parent': [],\n",
       "   'address': '环市东路166号广州城建职业学院内',\n",
       "   'distance': '13397',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '3.4'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;篮球场馆',\n",
       "   'photos': [],\n",
       "   'typecode': '080104',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '篮球场',\n",
       "   'location': '113.612905,23.524059',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFGBHSY7'},\n",
       "  {'parent': [],\n",
       "   'address': '绿道德福河畔花园-莱茵水岸东南侧约140米',\n",
       "   'distance': '14156',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '3.8'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;运动场所',\n",
       "   'photos': [],\n",
       "   'typecode': '080100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '林书豪-李群篮球联盟',\n",
       "   'location': '113.598957,23.524103',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HKH7ET45'},\n",
       "  {'parent': [],\n",
       "   'address': '沿江北路150号附近',\n",
       "   'distance': '15336',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '4.0'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;体育休闲服务场所;体育休闲服务场所',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://aos-cdn-image.amap.com/sns/ugccomment/f70753b9-7482-4834-83eb-d551515ab5a8.jpg'}],\n",
       "   'typecode': '080000',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '坑尾村篮球场',\n",
       "   'location': '113.531138,23.600104',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFKP84WT'},\n",
       "  {'parent': [],\n",
       "   'address': '江埔街南方村',\n",
       "   'distance': '15899',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '3.7'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;体育休闲服务场所;体育休闲服务场所',\n",
       "   'photos': [],\n",
       "   'typecode': '080000',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '南方村篮球场',\n",
       "   'location': '113.579487,23.517988',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HKOCIL77'},\n",
       "  {'parent': [],\n",
       "   'address': '员村美食街与广从公路交叉口东南420米',\n",
       "   'distance': '16479',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': []},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;篮球场馆',\n",
       "   'photos': [],\n",
       "   'typecode': '080104',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '华南农业大学珠江学院篮球场',\n",
       "   'location': '113.579948,23.510999',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HG27ZQU5'},\n",
       "  {'parent': [],\n",
       "   'address': '棋杆高沙街与棋杆沙围一街交叉口东南320米',\n",
       "   'distance': '20865',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [], 'rating': '3.6'},\n",
       "   'biz_type': [],\n",
       "   'cityname': '广州市',\n",
       "   'type': '体育休闲服务;运动场馆;篮球场馆',\n",
       "   'photos': [],\n",
       "   'typecode': '080104',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '瓦窑篮球场',\n",
       "   'location': '113.477748,23.591445',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0G10ACN4L'}],\n",
       " 'status': '1',\n",
       " 'info': 'OK'}"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "b32659a8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'suggestion': {'keywords': [], 'cities': []},\n",
       " 'count': '244',\n",
       " 'infocode': '10000',\n",
       " 'pois': [{'parent': [],\n",
       "   'address': '温泉乌土村随便公寓',\n",
       "   'distance': '744',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '开心便当',\n",
       "   'location': '113.680114,23.621967',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1ML1SQF'},\n",
       "  {'parent': [],\n",
       "   'address': '美味阁',\n",
       "   'distance': '770',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '2.5',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '忍者拉面(中大店)',\n",
       "   'location': '113.679780,23.621658',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H3XY2P42'},\n",
       "  {'parent': [],\n",
       "   'address': '广州南方学院东区食堂第四',\n",
       "   'distance': '781',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': '09:00-21:00',\n",
       "    'rating': '3.4',\n",
       "    'open_time': '09:00-21:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '汕头粿条汤',\n",
       "   'location': '113.682317,23.634404',\n",
       "   'tel': '13539626288',\n",
       "   'shopid': [],\n",
       "   'id': 'B0IBA9VKTX'},\n",
       "  {'parent': [],\n",
       "   'address': '广州南方学院宿舍一楼门口',\n",
       "   'distance': '795',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '广州南方学院东学楼30号-取餐柜',\n",
       "   'location': '113.682747,23.634293',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HK07OHB3'},\n",
       "  {'parent': [],\n",
       "   'address': '乌土村老虎形29号104',\n",
       "   'distance': '843',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '2.5',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '大胡子砂锅麻辣烫(中大店)',\n",
       "   'location': '113.679891,23.621011',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1M7XMPA'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇乌土村老虎型街2号',\n",
       "   'distance': '870',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050118',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '上一烧烤',\n",
       "   'location': '113.680262,23.620830',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HRO7M74I'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇龙泉路自编00945号之二、之三(乡村公寓旁)',\n",
       "   'distance': '955',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050118',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '夜烤(中大店)',\n",
       "   'location': '113.674410,23.620619',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCL0BJ'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇乌土村上围2队13号',\n",
       "   'distance': '1208',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.5',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '蒸美味(中大店)',\n",
       "   'location': '113.680637,23.617803',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1M701KN'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇乌土村上围2队13号',\n",
       "   'distance': '1251',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '开心花甲简餐(中大店)',\n",
       "   'location': '113.681729,23.617653',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCM2S7'},\n",
       "  {'parent': [],\n",
       "   'address': '广东省广州市从化区温泉镇金鸡村',\n",
       "   'distance': '1685',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.9',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/e1fbce962152269ce8e8337439faf543'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/93189de5d7da3e16ec5ee45138b49459'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/bcd951f0b726f17fe1128035036decab'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '小萌牛全民总动员',\n",
       "   'location': '113.677109,23.613332',\n",
       "   'tel': '15813351058',\n",
       "   'shopid': [],\n",
       "   'id': 'B0GUDHQSG9'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉大道(中山大学旁)卫东村卫东村委南侧50米处',\n",
       "   'distance': '2149',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '84.00',\n",
       "    'opentime2': [],\n",
       "    'rating': '4.5',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/a1a2e0ce8f90341a6ed407191ba219ff'},\n",
       "    {'title': [],\n",
       "     'url': 'http://aos-cdn-image.amap.com/sns/ugccomment/057b0581-fed7-4665-906e-7c268f5a59c5.jpg'},\n",
       "    {'title': [],\n",
       "     'url': 'http://aos-cdn-image.amap.com/sns/ugccomment/c7aefe58-08ee-4f2d-aecd-f5cf512c31a6.jpg'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '卫东农庄',\n",
       "   'location': '113.677608,23.647740',\n",
       "   'tel': '020-37977399',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFGKX9PY'},\n",
       "  {'parent': 'B0G1GMN7P5',\n",
       "   'address': '温泉镇永福新村5号',\n",
       "   'distance': '2228',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '72.00',\n",
       "    'opentime2': [],\n",
       "    'rating': '4.1',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/e305075a91afdc955a0f7019eeb828bd'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/84f0b0637def8d4833a90ec39502e4fa'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/222c7b0d4cd7d7dc8aa5f16b4c4ad457'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': '324',\n",
       "   'adname': '从化区',\n",
       "   'name': '凤仙餐馆',\n",
       "   'location': '113.661270,23.640879',\n",
       "   'tel': '020-87838990',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFHE66RZ'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇平岗村龙江里',\n",
       "   'distance': '2261',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '4.0',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/a411c32cc9bdea1f86b9baef0278924d'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '忆乡园农庄',\n",
       "   'location': '113.694008,23.614122',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFHQT3YZ'},\n",
       "  {'parent': 'B0G1GMN7P5',\n",
       "   'address': '温泉镇永福邨B座9-10号',\n",
       "   'distance': '2266',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '48.00',\n",
       "    'opentime2': '10:30-14:00；16:00-23:00',\n",
       "    'rating': '4.8',\n",
       "    'open_time': '10:30-14:00 16:00-23:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/6b93aa1a74a1aaf5a3642b145c680ff2'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/1b7047e16ead7cd033fa5e402727a145'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/1e1b784bea702c98474a93a8a7fc6c77'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': '324',\n",
       "   'adname': '从化区',\n",
       "   'name': '仙溪美食农庄20年老字号(温泉镇店)',\n",
       "   'location': '113.660610,23.640756',\n",
       "   'tel': '13725183498',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFFAIVRY'},\n",
       "  {'parent': 'B0G1GMN7P5',\n",
       "   'address': '温泉镇永福路1号永福漫街A区3楼301-302',\n",
       "   'distance': '2312',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': '17:30-01:30',\n",
       "    'rating': '4.0',\n",
       "    'open_time': '17:30-01:30',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/d4bed1302ad3537e94ec4af7aaebc55c'},\n",
       "    {'title': [],\n",
       "     'url': 'http://aos-cdn-image.amap.com/sns/ugccomment/202843a8-75dd-4d2e-98c4-213a74192166.jpg'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': '324',\n",
       "   'adname': '从化区',\n",
       "   'name': '空中之声烧烤吧',\n",
       "   'location': '113.659544,23.640329',\n",
       "   'tel': '13926235161',\n",
       "   'shopid': [],\n",
       "   'id': 'B0GK4ORPPU'},\n",
       "  {'parent': 'B0G1GMN7P5',\n",
       "   'address': '温泉镇永福漫街A区2楼',\n",
       "   'distance': '2318',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '56.00',\n",
       "    'opentime2': '10:00-22:00',\n",
       "    'rating': '4.5',\n",
       "    'open_time': '10:00-22:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/2044a40b170256a5fb05299e3af9f175'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/4f47d23da7c0958622760a4035567ee3'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/e017c519fb053cbf01614bf6bbb0fffa'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': '324',\n",
       "   'adname': '从化区',\n",
       "   'name': '温陶居私房菜',\n",
       "   'location': '113.659697,23.640419',\n",
       "   'tel': '13925068523',\n",
       "   'shopid': [],\n",
       "   'id': 'B0G304EZT6'},\n",
       "  {'parent': [],\n",
       "   'address': '源湖前街与龙泉路交叉口东南约220米',\n",
       "   'distance': '2363',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.9',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '荔蜜园餐厅',\n",
       "   'location': '113.662858,23.612591',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B00141JCPD'},\n",
       "  {'parent': 'B0G1GMN7P5',\n",
       "   'address': '温泉镇亨来斯登酒店',\n",
       "   'distance': '2403',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '2.4',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050118',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': '324',\n",
       "   'adname': '从化区',\n",
       "   'name': '德州烧烤(中大店)',\n",
       "   'location': '113.658707,23.640472',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCKB60'},\n",
       "  {'parent': 'B0G1GMN7P5',\n",
       "   'address': '温泉镇亨来斯登酒店',\n",
       "   'distance': '2403',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '2.3',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050118',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': '324',\n",
       "   'adname': '从化区',\n",
       "   'name': '和记烧烤(中大店)',\n",
       "   'location': '113.658707,23.640472',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1M7Y7LR'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇温泉东路1号(加油站斜坡隔壁)',\n",
       "   'distance': '2406',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '58.00',\n",
       "    'opentime2': '10:00-14:00；16:30-01:30',\n",
       "    'rating': '4.4',\n",
       "    'open_time': '10:00-14:00 16:30-01:30',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;广东菜(粤菜)',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/071726c1bd55bfe415522a316aad580d'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/b80d1a1da127837c7ffcf654d25802b4'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/a66185881412fc05d73fce7b318b35e2'}],\n",
       "   'typecode': '050103',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '品味烧鸡天下菜馆',\n",
       "   'location': '113.658187,23.639770',\n",
       "   'tel': '020-37502123',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFGW1SIX'}],\n",
       " 'status': '1',\n",
       " 'info': 'OK'}"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# types 编码表\n",
    "around_url = 'https://restapi.amap.com/v3/place/around?parameters'\n",
    "\n",
    "payload = {\n",
    "    \"key\":\"f7b3c94b56fe002e2b98f6bb8d8a5f46\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"types\":\"050100\",\n",
    "    'page':3\n",
    "}\n",
    "r = requests.get(around_url,params=payload)\n",
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "d789fb5b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "240778a2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>parent</th>\n",
       "      <th>address</th>\n",
       "      <th>distance</th>\n",
       "      <th>pname</th>\n",
       "      <th>importance</th>\n",
       "      <th>biz_type</th>\n",
       "      <th>cityname</th>\n",
       "      <th>type</th>\n",
       "      <th>photos</th>\n",
       "      <th>typecode</th>\n",
       "      <th>...</th>\n",
       "      <th>name</th>\n",
       "      <th>location</th>\n",
       "      <th>tel</th>\n",
       "      <th>shopid</th>\n",
       "      <th>id</th>\n",
       "      <th>biz_ext.cost</th>\n",
       "      <th>biz_ext.opentime2</th>\n",
       "      <th>biz_ext.rating</th>\n",
       "      <th>biz_ext.open_time</th>\n",
       "      <th>biz_ext.meal_ordering</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉乌土村随便公寓</td>\n",
       "      <td>744</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>开心便当</td>\n",
       "      <td>113.680114,23.621967</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H1ML1SQF</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[]</td>\n",
       "      <td>美味阁</td>\n",
       "      <td>770</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>忍者拉面(中大店)</td>\n",
       "      <td>113.679780,23.621658</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H3XY2P42</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.5</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[]</td>\n",
       "      <td>广州南方学院东区食堂第四</td>\n",
       "      <td>781</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>汕头粿条汤</td>\n",
       "      <td>113.682317,23.634404</td>\n",
       "      <td>13539626288</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0IBA9VKTX</td>\n",
       "      <td>[]</td>\n",
       "      <td>09:00-21:00</td>\n",
       "      <td>3.4</td>\n",
       "      <td>09:00-21:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[]</td>\n",
       "      <td>广州南方学院宿舍一楼门口</td>\n",
       "      <td>795</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>广州南方学院东学楼30号-取餐柜</td>\n",
       "      <td>113.682747,23.634293</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HK07OHB3</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[]</td>\n",
       "      <td>乌土村老虎形29号104</td>\n",
       "      <td>843</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>大胡子砂锅麻辣烫(中大店)</td>\n",
       "      <td>113.679891,23.621011</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H1M7XMPA</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.5</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇乌土村老虎型街2号</td>\n",
       "      <td>870</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>上一烧烤</td>\n",
       "      <td>113.680262,23.620830</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HRO7M74I</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇龙泉路自编00945号之二、之三(乡村公寓旁)</td>\n",
       "      <td>955</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>夜烤(中大店)</td>\n",
       "      <td>113.674410,23.620619</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCL0BJ</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇乌土村上围2队13号</td>\n",
       "      <td>1208</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>蒸美味(中大店)</td>\n",
       "      <td>113.680637,23.617803</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H1M701KN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.5</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇乌土村上围2队13号</td>\n",
       "      <td>1251</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>开心花甲简餐(中大店)</td>\n",
       "      <td>113.681729,23.617653</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCM2S7</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[]</td>\n",
       "      <td>广东省广州市从化区温泉镇金鸡村</td>\n",
       "      <td>1685</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>小萌牛全民总动员</td>\n",
       "      <td>113.677109,23.613332</td>\n",
       "      <td>15813351058</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0GUDHQSG9</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉大道(中山大学旁)卫东村卫东村委南侧50米处</td>\n",
       "      <td>2149</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>卫东农庄</td>\n",
       "      <td>113.677608,23.647740</td>\n",
       "      <td>020-37977399</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFGKX9PY</td>\n",
       "      <td>84.00</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.5</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>B0G1GMN7P5</td>\n",
       "      <td>温泉镇永福新村5号</td>\n",
       "      <td>2228</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>凤仙餐馆</td>\n",
       "      <td>113.661270,23.640879</td>\n",
       "      <td>020-87838990</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFHE66RZ</td>\n",
       "      <td>72.00</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.1</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇平岗村龙江里</td>\n",
       "      <td>2261</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>忆乡园农庄</td>\n",
       "      <td>113.694008,23.614122</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFHQT3YZ</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B0G1GMN7P5</td>\n",
       "      <td>温泉镇永福邨B座9-10号</td>\n",
       "      <td>2266</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>仙溪美食农庄20年老字号(温泉镇店)</td>\n",
       "      <td>113.660610,23.640756</td>\n",
       "      <td>13725183498</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFFAIVRY</td>\n",
       "      <td>48.00</td>\n",
       "      <td>10:30-14:00；16:00-23:00</td>\n",
       "      <td>4.8</td>\n",
       "      <td>10:30-14:00 16:00-23:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>B0G1GMN7P5</td>\n",
       "      <td>温泉镇永福路1号永福漫街A区3楼301-302</td>\n",
       "      <td>2312</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>空中之声烧烤吧</td>\n",
       "      <td>113.659544,23.640329</td>\n",
       "      <td>13926235161</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0GK4ORPPU</td>\n",
       "      <td>[]</td>\n",
       "      <td>17:30-01:30</td>\n",
       "      <td>4.0</td>\n",
       "      <td>17:30-01:30</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>B0G1GMN7P5</td>\n",
       "      <td>温泉镇永福漫街A区2楼</td>\n",
       "      <td>2318</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>温陶居私房菜</td>\n",
       "      <td>113.659697,23.640419</td>\n",
       "      <td>13925068523</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0G304EZT6</td>\n",
       "      <td>56.00</td>\n",
       "      <td>10:00-22:00</td>\n",
       "      <td>4.5</td>\n",
       "      <td>10:00-22:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>[]</td>\n",
       "      <td>源湖前街与龙泉路交叉口东南约220米</td>\n",
       "      <td>2363</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>荔蜜园餐厅</td>\n",
       "      <td>113.662858,23.612591</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00141JCPD</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>B0G1GMN7P5</td>\n",
       "      <td>温泉镇亨来斯登酒店</td>\n",
       "      <td>2403</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>德州烧烤(中大店)</td>\n",
       "      <td>113.658707,23.640472</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCKB60</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.4</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>B0G1GMN7P5</td>\n",
       "      <td>温泉镇亨来斯登酒店</td>\n",
       "      <td>2403</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>和记烧烤(中大店)</td>\n",
       "      <td>113.658707,23.640472</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H1M7Y7LR</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.3</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇温泉东路1号(加油站斜坡隔壁)</td>\n",
       "      <td>2406</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;广东菜(粤菜)</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050103</td>\n",
       "      <td>...</td>\n",
       "      <td>品味烧鸡天下菜馆</td>\n",
       "      <td>113.658187,23.639770</td>\n",
       "      <td>020-37502123</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFGW1SIX</td>\n",
       "      <td>58.00</td>\n",
       "      <td>10:00-14:00；16:30-01:30</td>\n",
       "      <td>4.4</td>\n",
       "      <td>10:00-14:00 16:30-01:30</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        parent                     address distance pname importance biz_type  \\\n",
       "0           []                   温泉乌土村随便公寓      744   广东省         []    diner   \n",
       "1           []                         美味阁      770   广东省         []    diner   \n",
       "2           []                广州南方学院东区食堂第四      781   广东省         []    diner   \n",
       "3           []                广州南方学院宿舍一楼门口      795   广东省         []    diner   \n",
       "4           []                乌土村老虎形29号104      843   广东省         []    diner   \n",
       "5           []                温泉镇乌土村老虎型街2号      870   广东省         []    diner   \n",
       "6           []  温泉镇龙泉路自编00945号之二、之三(乡村公寓旁)      955   广东省         []    diner   \n",
       "7           []               温泉镇乌土村上围2队13号     1208   广东省         []    diner   \n",
       "8           []               温泉镇乌土村上围2队13号     1251   广东省         []    diner   \n",
       "9           []             广东省广州市从化区温泉镇金鸡村     1685   广东省         []    diner   \n",
       "10          []    温泉大道(中山大学旁)卫东村卫东村委南侧50米处     2149   广东省         []    diner   \n",
       "11  B0G1GMN7P5                   温泉镇永福新村5号     2228   广东省         []    diner   \n",
       "12          []                   温泉镇平岗村龙江里     2261   广东省         []    diner   \n",
       "13  B0G1GMN7P5               温泉镇永福邨B座9-10号     2266   广东省         []    diner   \n",
       "14  B0G1GMN7P5     温泉镇永福路1号永福漫街A区3楼301-302     2312   广东省         []    diner   \n",
       "15  B0G1GMN7P5                 温泉镇永福漫街A区2楼     2318   广东省         []    diner   \n",
       "16          []          源湖前街与龙泉路交叉口东南约220米     2363   广东省         []    diner   \n",
       "17  B0G1GMN7P5                   温泉镇亨来斯登酒店     2403   广东省         []    diner   \n",
       "18  B0G1GMN7P5                   温泉镇亨来斯登酒店     2403   广东省         []    diner   \n",
       "19          []          温泉镇温泉东路1号(加油站斜坡隔壁)     2406   广东省         []    diner   \n",
       "\n",
       "   cityname                type  \\\n",
       "0       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "1       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "2       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "3       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "4       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "5       广州市  餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "6       广州市  餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "7       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "8       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "9       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "10      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "11      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "12      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "13      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "14      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "15      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "16      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "17      广州市  餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "18      广州市  餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "19      广州市    餐饮服务;中餐厅;广东菜(粤菜)   \n",
       "\n",
       "                                               photos typecode  ...  \\\n",
       "0                                                  []   050100  ...   \n",
       "1                                                  []   050100  ...   \n",
       "2                                                  []   050100  ...   \n",
       "3                                                  []   050100  ...   \n",
       "4                                                  []   050100  ...   \n",
       "5                                                  []   050118  ...   \n",
       "6                                                  []   050118  ...   \n",
       "7                                                  []   050100  ...   \n",
       "8                                                  []   050100  ...   \n",
       "9   [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "10  [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "11  [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "12  [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "13  [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "14  [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "15  [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "16                                                 []   050100  ...   \n",
       "17                                                 []   050118  ...   \n",
       "18                                                 []   050118  ...   \n",
       "19  [{'title': [], 'url': 'http://store.is.autonav...   050103  ...   \n",
       "\n",
       "                  name              location           tel shopid          id  \\\n",
       "0                 开心便当  113.680114,23.621967            []     []  B0H1ML1SQF   \n",
       "1            忍者拉面(中大店)  113.679780,23.621658            []     []  B0H3XY2P42   \n",
       "2                汕头粿条汤  113.682317,23.634404   13539626288     []  B0IBA9VKTX   \n",
       "3     广州南方学院东学楼30号-取餐柜  113.682747,23.634293            []     []  B0HK07OHB3   \n",
       "4        大胡子砂锅麻辣烫(中大店)  113.679891,23.621011            []     []  B0H1M7XMPA   \n",
       "5                 上一烧烤  113.680262,23.620830            []     []  B0HRO7M74I   \n",
       "6              夜烤(中大店)  113.674410,23.620619            []     []  B0HROCL0BJ   \n",
       "7             蒸美味(中大店)  113.680637,23.617803            []     []  B0H1M701KN   \n",
       "8          开心花甲简餐(中大店)  113.681729,23.617653            []     []  B0HROCM2S7   \n",
       "9             小萌牛全民总动员  113.677109,23.613332   15813351058     []  B0GUDHQSG9   \n",
       "10                卫东农庄  113.677608,23.647740  020-37977399     []  B0FFGKX9PY   \n",
       "11                凤仙餐馆  113.661270,23.640879  020-87838990     []  B0FFHE66RZ   \n",
       "12               忆乡园农庄  113.694008,23.614122            []     []  B0FFHQT3YZ   \n",
       "13  仙溪美食农庄20年老字号(温泉镇店)  113.660610,23.640756   13725183498     []  B0FFFAIVRY   \n",
       "14             空中之声烧烤吧  113.659544,23.640329   13926235161     []  B0GK4ORPPU   \n",
       "15              温陶居私房菜  113.659697,23.640419   13925068523     []  B0G304EZT6   \n",
       "16               荔蜜园餐厅  113.662858,23.612591            []     []  B00141JCPD   \n",
       "17           德州烧烤(中大店)  113.658707,23.640472            []     []  B0HROCKB60   \n",
       "18           和记烧烤(中大店)  113.658707,23.640472            []     []  B0H1M7Y7LR   \n",
       "19            品味烧鸡天下菜馆  113.658187,23.639770  020-37502123     []  B0FFGW1SIX   \n",
       "\n",
       "   biz_ext.cost        biz_ext.opentime2 biz_ext.rating  \\\n",
       "0            []                       []             []   \n",
       "1            []                       []            2.5   \n",
       "2            []              09:00-21:00            3.4   \n",
       "3            []                       []             []   \n",
       "4            []                       []            2.5   \n",
       "5            []                       []             []   \n",
       "6            []                       []             []   \n",
       "7            []                       []            3.5   \n",
       "8            []                       []             []   \n",
       "9            []                       []            3.9   \n",
       "10        84.00                       []            4.5   \n",
       "11        72.00                       []            4.1   \n",
       "12           []                       []            4.0   \n",
       "13        48.00  10:30-14:00；16:00-23:00            4.8   \n",
       "14           []              17:30-01:30            4.0   \n",
       "15        56.00              10:00-22:00            4.5   \n",
       "16           []                       []            3.9   \n",
       "17           []                       []            2.4   \n",
       "18           []                       []            2.3   \n",
       "19        58.00  10:00-14:00；16:30-01:30            4.4   \n",
       "\n",
       "          biz_ext.open_time biz_ext.meal_ordering  \n",
       "0                        []                     0  \n",
       "1                        []                     0  \n",
       "2               09:00-21:00                     0  \n",
       "3                        []                     0  \n",
       "4                        []                     0  \n",
       "5                        []                     0  \n",
       "6                        []                     0  \n",
       "7                        []                     0  \n",
       "8                        []                     0  \n",
       "9                        []                     0  \n",
       "10                       []                     0  \n",
       "11                       []                     0  \n",
       "12                       []                     0  \n",
       "13  10:30-14:00 16:00-23:00                     0  \n",
       "14              17:30-01:30                     0  \n",
       "15              10:00-22:00                     0  \n",
       "16                       []                     0  \n",
       "17                       []                     0  \n",
       "18                       []                     0  \n",
       "19  10:00-14:00 16:30-01:30                     0  \n",
       "\n",
       "[20 rows x 24 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.json_normalize(r.json()['pois'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "98bccb7c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 小程序appid：wxa54b6276eee3478b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0515fe43",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
